﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MisDLL;
using System.Data;
using IBLL;

namespace MisBLL
{
    //操作用户配置业务操作类
    public class OperDAO : BaseDAO, IOper
    {

        //根据操作者部门，操作编号和密码得到操作者信息
        public DataTable GetOper(string OperId, string DepId, string Passwd)
        {
            if (string.IsNullOrEmpty(OperId) || string.IsNullOrEmpty(DepId) || string.IsNullOrEmpty(Passwd))
                return null;
            string sql = string.Format("SELECT oper_id,oper,dep_id,class,cando,passwd FROM OPER_TAB WHERE OPER_ID='{0}' and dep_id='{1}' and passwd='{2}'", OperId, DepId, Passwd);
            return dbHelper.ExecuteDataTable(sql);
        }
    }
}
